<?php
$SQLconnect = mysql_connect("localhost","indoor","outdoor");
$SQLlist = "SELECT * FROM best_videos";
	
if (!$SQLconnect) { echo("SQL Connection Error: " . mysql_error() . "\n");	}

else {
	$SQLexecute = mysql_db_query("indoor",$SQLlist,$SQLconnect);
	if (!$SQLexecute) { echo("SQL Execution Error: " . mysql_error() . "\n$SQL\n");	}
	else {
		while($rowArray = mysql_fetch_array($SQLexecute,MYSQL_ASSOC)) {;
			$bodyString .= "
<div class='best_videos_record'>";		$sort_order = $rowArray["sort_order"];
		$title = $rowArray["title"];
		$height = $rowArray["height"];
		$width = $rowArray["width"];
		$videoFile = $rowArray["videoFile"];
		$extraInfo = $rowArray["extraInfo"];
		$id = $rowArray["id"];

		$bodyString .= "\n<div class='frontListElement'>Title: $title</div>";
		$bodyString .= "\n<div class='frontListElement'>Video Height (pixels): $height</div>";
		$bodyString .= "\n<div class='frontListElement'>Video Width (pixels): $width</div>";
		$bodyString .= "\n<div class='frontListElement'>Credits / Extra Info: $extraInfo</div>";
	
			$bodyString .= "
</div>";					
		}
	}
}
mysql_close($SQLconnect);
?>
<html>
	<head>
		<title>best_videos Front</title>
	<link rel="stylesheet" type="text/css" href="io_cms.css" />
	</head>
	<body><?php echo $bodyString; ?>
	

	</body>
</html>